* Compute some totals before sample selection

include choose_version.do

putexcel set $figure_path/cps_results_`version_robust'.xlsx, sheet(transfer_totals) replace open
putexcel A1 = "Program"
putexcel B1 = "Total Pre Sample Selection"
putexcel C1 = "Total Post Sample Selection"

total snap_impute_val_hh [fw = asecwth]
putexcel A2 = "SNAP"
putexcel B2 = (r(table)[1,1])

total ssi_impute_val_hh [fw = asecwth]
putexcel A3 = "SSI"
putexcel B3 = (r(table)[1,1])

total housing_assist_impute_val_hh [fw = asecwth]
putexcel A4 = "Housing Assistance"
putexcel B4 = (r(table)[1,1])

total incwelfr_hh [fw = asecwth]
putexcel A5 = "Welfare"
putexcel B5 = (r(table)[1,1])

total mcaid_impute_val_hh [fw = asecwth]
putexcel A6 = "Medicaid"
putexcel B6 = (r(table)[1,1])

total ctccrd_hh [fw = asecwth]
putexcel A7 = "CTC"
putexcel B7 = (r(table)[1,1])

total actccrd_hh [fw = asecwth]
putexcel A8 = "ACTC"
putexcel B8 = (r(table)[1,1])

total eitcred_hh [fw = asecwth]
putexcel A9 = "EITC"
putexcel B9 = (r(table)[1,1])

putexcel save